package com.teach.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.teach.dto.HotelRoomInfoDTO;
import com.teach.entity.HotelRoomType;

public interface HotelRoomTypeMapper {
    int deleteByPrimaryKey(Integer roomTypeId);

    int insert(HotelRoomType record);

    int insertSelective(HotelRoomType record);

    HotelRoomType selectByPrimaryKey(Integer roomTypeId);

    int updateByPrimaryKeySelective(HotelRoomType record);

    int updateByPrimaryKey(HotelRoomType record);
    
    @Select("select room_type_id from hotel_room_type where room_type_name=#{roomTypeName}")
    int selectRoomTypeId(String roomTypeName);
    
	@Select("select * from hotel_room_type")
	List<HotelRoomType> selectAll();
	
	@Select("select room_type_name from hotel_room_type where room_type_id=#{roomTypeId}")
	String selectRoomTypeName(Integer roomTypeId);
}